package appapi.dao;

import appapi.Request.AppSelfcheckPageReq;
import appapi.Request.SelfcheckPageReq;
import appapi.Vo.AddSelfcheckVo;
import appapi.Vo.basic.ExcelSelfcheckVo;
import appapi.entity.Zhongjiao.SelfcheckDto;
import appapi.entity.basic.SelfcheckItemEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;import java.util.Map;

/**
 * @author djq
 * @date 2023/5/18 11:13
 * @description:
 */

@Mapper
public interface SelfcheckMapper {
    int deleteByPrimaryKey(Long selfId);

    int deleteBatch(@Param("selfIds") List<Long> selfIds);

    int insert(SelfcheckDto record);

    int insertSelective(SelfcheckDto record);

    SelfcheckDto selectByPrimaryKey(Long selfId);

    int updateByPrimaryKeySelective(SelfcheckDto record);

    int updateByPrimaryKey(SelfcheckDto record);

    List<Map<String, Object>> selectList(String equip_no);

    List<Map<String, Object>> selectPage(SelfcheckPageReq selfcheckPageReq);

    List<Map<String, Object>> selectSelfcheckList(Long equipId);

    List<Map<String, Object>> selectPageList(AppSelfcheckPageReq appSelfcheckPageReq);

    long insertSelfcheck(AddSelfcheckVo addSelfcheckVo);

    List<Map<String, Object>> selectListByMonth(@Param("equipIds") List<Long> equipIds);

    List<ExcelSelfcheckVo> SelfRecExport(SelfcheckPageReq req);

    Integer getCount();
    Integer getCounts(@Param("orgaId") Long orgaId);

    List<Long> getselfByOrgId(Long orgaId);

    List<Long> getOnsiteByOrgId(Long orgaId);

    List<Long> getMouthByOrgId(Long orgaId);

    List<Long> getRectByOrgId(Long orgaId);

    List<Long> getSectionByOrgId(Long orgaId);

}